package cn.com.sinosoft.ares.insurance.dao;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

/**
 * Description: 公司信息配置
 * Author: lishangmin
 * Created: 2018-06-25 16:33
 */
@Mapper
@Repository
public interface PrpDCompanyDao {

    @Select("select newcomcode from prpdcompany a, prpduser c where c.usercode=#{userCode} and c.comcode = a.comcode")
    String selectNewComCodeByUserCode(@Param("userCode") String userCode);

    @Select("select newcomcode from prpdcompany a where a.comcode=#{comCode}")
    String selectNewComCodeByComCode(@Param("comCode") String comCode);

    @Select("select agentcode from prpdcompany a where a.userCode=#{userCode}")
    String selectagentcodeByComCode(@Param("userCode") String userCode);

}
